sql / as sysdba

STARTUP PFILE='/tmp/plik_pfile.ora';

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=60 SCOPE=MEMORY;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=60 SCOPE=SPFILE;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=60 SCOPE=BOTH;

CREATE SPFILE FROM PFILE;

CREATE PFILE FROM SPFILE;

CREATE PFILE='/tmp/plik_pfile.ora' FROM SPFILE;

SHOW PARAMETERS

SHOW PARAMETERS DEST

ALTER SYSTEM SET PARAMETR=wartość CONTAINER=CURRENT;

ALTER SYSTEM SET PARAMETR=wartość CONTAINER=ALL;

SELECT NAME, VALUE, ISSES_MODIFIABLE, ISSYS_MODIFIABLE, ISPDB_MODIFIABLE FROM V$PARAMETER;

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';



Parametr jądra systemu Linux - vm.swappiness

sysctl vm.swappiness

vi /etc/sysctl.d/99-oracle-memory.conf

vm.swappiness=10

sysctl --system
